Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	40000
Missing cells	32187
Missing cells (%)	5.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.6 MiB
Average record size in memory	120.0 B

Variable types

Numeric	12
Categorical	3

Alerts

`energy` is highly correlated with `loudness`	High correlation
`loudness` is highly correlated with `energy`	High correlation
`acousticness` is highly correlated with `energy` and 1 other fields	High correlation
`energy` is highly correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly correlated with `acousticness` and 1 other fields	High correlation
`acousticness` is highly correlated with `energy` and 1 other fields	High correlation
`energy` is highly correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly correlated with `acousticness` and 1 other fields	High correlation
`song_duration_ms` has 4101 (10.3%) missing values	Missing
`acousticness` has 3992 (10.0%) missing values	Missing
`danceability` has 4026 (10.1%) missing values	Missing
`energy` has 3975 (9.9%) missing values	Missing
`instrumentalness` has 3985 (10.0%) missing values	Missing
`key` has 4065 (10.2%) missing values	Missing
`liveness` has 4086 (10.2%) missing values	Missing
`loudness` has 3957 (9.9%) missing values	Missing
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`key` has 5175 (12.9%) zeros	Zeros

Reproduction

Analysis started	2022-01-28 17:49:29.316453
Analysis finished	2022-01-28 17:50:05.102063
Duration	35.79 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	40000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19999.5

Minimum	0
Maximum	39999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1999.95
Q1	9999.75
median	19999.5
Q3	29999.25
95-th percentile	37999.05
Maximum	39999
Range	39999
Interquartile range (IQR)	19999.5

Descriptive statistics

Standard deviation	11547.14972
Coefficient of variation (CV)	0.5773719203
Kurtosis	-1.2
Mean	19999.5
Median Absolute Deviation (MAD)	10000
Skewness	0
Sum	799980000
Variance	133336666.7
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
35492	1	< 0.1%
25241	1	< 0.1%
31386	1	< 0.1%
29339	1	< 0.1%
19100	1	< 0.1%
17053	1	< 0.1%
23198	1	< 0.1%
21151	1	< 0.1%
33445	1	< 0.1%
Other values (39990)	39990	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
39999	1	< 0.1%
39998	1	< 0.1%
39997	1	< 0.1%
39996	1	< 0.1%
39995	1	< 0.1%
39994	1	< 0.1%
39993	1	< 0.1%
39992	1	< 0.1%
39991	1	< 0.1%
39990	1	< 0.1%

song_duration_ms
Real number (ℝ_≥0)

MISSING

Distinct	31586
Distinct (%)	88.0%
Missing	4101
Missing (%)	10.3%
Infinite	0
Infinite (%)	0.0%
Mean	193165.8476

Minimum	25658
Maximum	491671
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	25658
5-th percentile	127469.5
Q1	166254.5
median	186660
Q3	215116
95-th percentile	277074.1
Maximum	491671
Range	466013
Interquartile range (IQR)	48861.5

Descriptive statistics

Standard deviation	45822.12768
Coefficient of variation (CV)	0.2372165072
Kurtosis	1.654184865
Mean	193165.8476
Median Absolute Deviation (MAD)	23432
Skewness	0.632931575
Sum	6934460762
Variance	2099667385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
162048	6	< 0.1%
160369	5	< 0.1%
174546	5	< 0.1%
191521	4	< 0.1%
166676	4	< 0.1%
166747	4	< 0.1%
183534	4	< 0.1%
182627	4	< 0.1%
187889	4	< 0.1%
172888	4	< 0.1%
Other values (31576)	35855	89.6%
(Missing)	4101	10.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
25658	1	< 0.1%
33994	1	< 0.1%
34816	1	< 0.1%
38861	1	< 0.1%
42109	1	< 0.1%
42856	1	< 0.1%
43971	1	< 0.1%
44008	1	< 0.1%
44834	1	< 0.1%
44839	1	< 0.1%

Value	Count	Frequency (%)
491671	1	< 0.1%
470577	1	< 0.1%
465636	1	< 0.1%
444971	1	< 0.1%
441046	1	< 0.1%
428156	1	< 0.1%
427888	1	< 0.1%
424144	1	< 0.1%
424135	1	< 0.1%
422771	1	< 0.1%

acousticness
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	36004
Distinct (%)	> 99.9%
Missing	3992
Missing (%)	10.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2764044304

Minimum	-0.01355115526
Maximum	1.065284361
Zeros	0
Zeros (%)	0.0%
Negative	372
Negative (%)	0.9%
Memory size	312.6 KiB

Quantile statistics

Minimum	-0.01355115526
5-th percentile	0.006948470296
Q1	0.0396183645
median	0.1405323489
Q3	0.4824987531
95-th percentile	0.9144326981
Maximum	1.065284361
Range	1.078835516
Interquartile range (IQR)	0.4428803886

Descriptive statistics

Standard deviation	0.2979279293
Coefficient of variation (CV)	1.077869587
Kurtosis	-0.3117888002
Mean	0.2764044304
Median Absolute Deviation (MAD)	0.1257318182
Skewness	1.004194448
Sum	9952.770729
Variance	0.08876105104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1298648705	2	< 0.1%
0.2686247767	2	< 0.1%
0.01231633709	2	< 0.1%
0.02305824137	2	< 0.1%
0.1299048141	1	< 0.1%
0.1603511393	1	< 0.1%
0.6220500299	1	< 0.1%
0.1369081355	1	< 0.1%
0.3712757452	1	< 0.1%
0.8582999413	1	< 0.1%
Other values (35994)	35994	90.0%
(Missing)	3992	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.01355115526	1	< 0.1%
-0.01224546206	1	< 0.1%
-0.01215610495	1	< 0.1%
-0.01099993806	1	< 0.1%
-0.0108470341	1	< 0.1%
-0.01076639126	1	< 0.1%
-0.01035210674	1	< 0.1%
-0.009692163825	1	< 0.1%
-0.009676017858	1	< 0.1%
-0.009572675809	1	< 0.1%

Value	Count	Frequency (%)
1.065284361	1	< 0.1%
1.062515738	1	< 0.1%
1.062462697	1	< 0.1%
1.051164071	1	< 0.1%
1.045537383	1	< 0.1%
1.043691471	1	< 0.1%
1.04108687	1	< 0.1%
1.040336623	1	< 0.1%
1.037488945	1	< 0.1%
1.036745377	1	< 0.1%

danceability
Real number (ℝ_≥0)

MISSING

Distinct	35972
Distinct (%)	> 99.9%
Missing	4026
Missing (%)	10.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.5709511548

Minimum	0.04396067634
Maximum	0.9571308047
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.04396067634
5-th percentile	0.2329293652
Q1	0.4247604608
median	0.6082338356
Q3	0.7184637554
95-th percentile	0.839682299
Maximum	0.9571308047
Range	0.9131701284
Interquartile range (IQR)	0.2937032947

Descriptive statistics

Standard deviation	0.1900104818
Coefficient of variation (CV)	0.3327963875
Kurtosis	-0.8125678234
Mean	0.5709511548
Median Absolute Deviation (MAD)	0.137040659
Skewness	-0.3983857384
Sum	20539.39684
Variance	0.03610398319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3484417356	2	< 0.1%
0.4822726741	2	< 0.1%
0.7295594728	1	< 0.1%
0.15499943	1	< 0.1%
0.1824723205	1	< 0.1%
0.45001977	1	< 0.1%
0.6335571136	1	< 0.1%
0.7641628936	1	< 0.1%
0.4916792322	1	< 0.1%
0.6922194535	1	< 0.1%
Other values (35962)	35962	89.9%
(Missing)	4026	10.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.04396067634	1	< 0.1%
0.04980707564	1	< 0.1%
0.05368199231	1	< 0.1%
0.05626872024	1	< 0.1%
0.05707968785	1	< 0.1%
0.05913749752	1	< 0.1%
0.06383802657	1	< 0.1%
0.06813417292	1	< 0.1%
0.06943161099	1	< 0.1%
0.07296815652	1	< 0.1%

Value	Count	Frequency (%)
0.9571308047	1	< 0.1%
0.9549446559	1	< 0.1%
0.950358401	1	< 0.1%
0.9477322566	1	< 0.1%
0.940680788	1	< 0.1%
0.9395229394	1	< 0.1%
0.935242386	1	< 0.1%
0.9331280429	1	< 0.1%
0.9331100089	1	< 0.1%
0.9329243581	1	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	36021
Distinct (%)	> 99.9%
Missing	3975
Missing (%)	9.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.6839319477

Minimum	-0.001682200414
Maximum	1.039741305
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	312.6 KiB

Quantile statistics

Minimum	-0.001682200414
5-th percentile	0.2827326087
Q1	0.5392758057
median	0.7044533183
Q3	0.8705031183
95-th percentile	0.9606421252
Maximum	1.039741305
Range	1.041423505
Interquartile range (IQR)	0.3312273125

Descriptive statistics

Standard deviation	0.2126620002
Coefficient of variation (CV)	0.3109402929
Kurtosis	-0.4092486749
Mean	0.6839319477
Median Absolute Deviation (MAD)	0.1657402625
Skewness	-0.5828321649
Sum	24638.64842
Variance	0.04522512632
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.8348283406	2	< 0.1%
0.7988072464	2	< 0.1%
0.894791715	2	< 0.1%
0.8531411891	2	< 0.1%
0.6859723922	1	< 0.1%
0.8525037041	1	< 0.1%
0.6390753865	1	< 0.1%
0.6296781648	1	< 0.1%
0.8642854442	1	< 0.1%
0.6626464467	1	< 0.1%
Other values (36011)	36011	90.0%
(Missing)	3975	9.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.001682200414	1	< 0.1%
0.002322425173	1	< 0.1%
0.007113470935	1	< 0.1%
0.01673206131	1	< 0.1%
0.01804640285	1	< 0.1%
0.01835167109	1	< 0.1%
0.02139428561	1	< 0.1%
0.02275668041	1	< 0.1%
0.02382117205	1	< 0.1%
0.02728486912	1	< 0.1%

Value	Count	Frequency (%)
1.039741305	1	< 0.1%
1.034280588	1	< 0.1%
1.033746655	1	< 0.1%
1.033434247	1	< 0.1%
1.033239424	1	< 0.1%
1.030409413	1	< 0.1%
1.029799364	1	< 0.1%
1.028632224	1	< 0.1%
1.028342585	1	< 0.1%
1.028060551	1	< 0.1%

instrumentalness
Real number (ℝ)

MISSING

Distinct	35999
Distinct (%)	> 99.9%
Missing	3985
Missing (%)	10.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03652675599

Minimum	-0.004398050997
Maximum	1.075414681
Zeros	0
Zeros (%)	0.0%
Negative	3216
Negative (%)	8.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	-0.004398050997
5-th percentile	-0.0004201654271
Q1	0.0009414648076
median	0.00197447663
Q3	0.003225298806
95-th percentile	0.1489803127
Maximum	1.075414681
Range	1.079812732
Interquartile range (IQR)	0.002283833998

Descriptive statistics

Standard deviation	0.1500239025
Coefficient of variation (CV)	4.107233135
Kurtosis	24.17958059
Mean	0.03652675599
Median Absolute Deviation (MAD)	0.001120578988
Skewness	4.947630572
Sum	1315.511117
Variance	0.02250717132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.001850425736	2	< 0.1%
0.001805457303	2	< 0.1%
0.001291602062	2	< 0.1%
0.001272046579	2	< 0.1%
0.002380006189	2	< 0.1%
0.001531513764	2	< 0.1%
0.001718744122	2	< 0.1%
0.002315629083	2	< 0.1%
0.0004818401054	2	< 0.1%
0.002195156381	2	< 0.1%
Other values (35989)	35995	90.0%
(Missing)	3985	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.004398050997	1	< 0.1%
-0.003854102211	1	< 0.1%
-0.003641069423	1	< 0.1%
-0.003257875762	1	< 0.1%
-0.003226164562	1	< 0.1%
-0.003087703173	1	< 0.1%
-0.003017105748	1	< 0.1%
-0.002977129903	1	< 0.1%
-0.002950045953	1	< 0.1%
-0.002839981101	1	< 0.1%

Value	Count	Frequency (%)
1.075414681	1	< 0.1%
1.064847378	1	< 0.1%
1.041479479	1	< 0.1%
1.036928136	1	< 0.1%
1.030262682	1	< 0.1%
1.029300219	1	< 0.1%
1.022304142	1	< 0.1%
1.015568836	1	< 0.1%
1.012839849	1	< 0.1%
1.012354366	1	< 0.1%

key
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	4065
Missing (%)	10.2%
Infinite	0
Infinite (%)	0.0%
Mean	5.042604703

Minimum	0
Maximum	11
Zeros	5175
Zeros (%)	12.9%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	10
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.372727801
Coefficient of variation (CV)	0.6688463601
Kurtosis	-1.274787585
Mean	5.042604703
Median Absolute Deviation (MAD)	3
Skewness	-0.07530404301
Sum	181206
Variance	11.37529282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	5175	12.9%
6	4949	12.4%
10	4302	10.8%
2	4080	10.2%
8	3028	7.6%
5	2985	7.5%
9	2881	7.2%
7	2690	6.7%
4	2239	5.6%
1	2143	5.4%
Other values (2)	1463	3.7%
(Missing)	4065	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5175	12.9%
1	2143	5.4%
2	4080	10.2%
3	1346	3.4%
4	2239	5.6%
5	2985	7.5%
6	4949	12.4%
7	2690	6.7%
8	3028	7.6%
9	2881	7.2%

Value	Count	Frequency (%)
11	117	0.3%
10	4302	10.8%
9	2881	7.2%
8	3028	7.6%
7	2690	6.7%
6	4949	12.4%
5	2985	7.5%
4	2239	5.6%
3	1346	3.4%
2	4080	10.2%

liveness
Real number (ℝ_≥0)

MISSING

Distinct	35911
Distinct (%)	> 99.9%
Missing	4086
Missing (%)	10.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.1985136912

Minimum	0.02784311302
Maximum	1.065298031
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.02784311302
5-th percentile	0.07990015233
Q1	0.1117963607
median	0.1359451827
Q3	0.2128416344
95-th percentile	0.5817990771
Maximum	1.065298031
Range	1.037454918
Interquartile range (IQR)	0.1010452737

Descriptive statistics

Standard deviation	0.1516699134
Coefficient of variation (CV)	0.7640274707
Kurtosis	4.411722538
Mean	0.1985136912
Median Absolute Deviation (MAD)	0.03733661592
Skewness	2.165545688
Sum	7129.420707
Variance	0.02300376264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1364655957	2	< 0.1%
0.1192752827	2	< 0.1%
0.1317763064	2	< 0.1%
0.5903744356	1	< 0.1%
0.2207329301	1	< 0.1%
0.1043682297	1	< 0.1%
0.1997512769	1	< 0.1%
0.2012847652	1	< 0.1%
0.120359166	1	< 0.1%
0.4660245776	1	< 0.1%
Other values (35901)	35901	89.8%
(Missing)	4086	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.02784311302	1	< 0.1%
0.03029814242	1	< 0.1%
0.03125165841	1	< 0.1%
0.03230646959	1	< 0.1%
0.03278167164	1	< 0.1%
0.03452495219	1	< 0.1%
0.03459704388	1	< 0.1%
0.03528012524	1	< 0.1%
0.03611065173	1	< 0.1%
0.0369193823	1	< 0.1%

Value	Count	Frequency (%)
1.065298031	1	< 0.1%
1.0286	1	< 0.1%
0.9902235113	1	< 0.1%
0.9804107246	1	< 0.1%
0.9796324509	1	< 0.1%
0.9784863951	1	< 0.1%
0.9754442737	1	< 0.1%
0.9703675478	1	< 0.1%
0.9591490081	1	< 0.1%
0.9544000324	1	< 0.1%

loudness
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	36038
Distinct (%)	> 99.9%
Missing	3957
Missing (%)	9.9%
Infinite	0
Infinite (%)	0.0%
Mean	-7.407596208

Minimum	-32.11791085
Maximum	-0.8773458492
Zeros	0
Zeros (%)	0.0%
Negative	36043
Negative (%)	90.1%
Memory size	312.6 KiB

Quantile statistics

Minimum	-32.11791085
5-th percentile	-14.81626983
Q1	-9.578139218
median	-6.345412615
Q3	-4.620711264
95-th percentile	-3.029093555
Maximum	-0.8773458492
Range	31.240565
Interquartile range (IQR)	4.957427954

Descriptive statistics

Standard deviation	3.877197599
Coefficient of variation (CV)	-0.5234083353
Kurtosis	2.79043824
Mean	-7.407596208
Median Absolute Deviation (MAD)	2.118409249
Skewness	-1.430100333
Sum	-266991.9901
Variance	15.03266123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-4.824933232	2	< 0.1%
-2.703761573	2	< 0.1%
-9.930080784	2	< 0.1%
-11.10901141	2	< 0.1%
-5.754275152	2	< 0.1%
-3.986829937	1	< 0.1%
-12.3152942	1	< 0.1%
-13.06102649	1	< 0.1%
-9.743439882	1	< 0.1%
-21.76251432	1	< 0.1%
Other values (36028)	36028	90.1%
(Missing)	3957	9.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-32.11791085	1	< 0.1%
-30.17039853	1	< 0.1%
-30.09107426	1	< 0.1%
-30.08884236	1	< 0.1%
-30.01238622	1	< 0.1%
-29.597087	1	< 0.1%
-29.36123409	1	< 0.1%
-29.1999107	1	< 0.1%
-29.17544778	1	< 0.1%
-29.04399434	1	< 0.1%

Value	Count	Frequency (%)
-0.8773458492	1	< 0.1%
-1.073216639	1	< 0.1%
-1.099458021	1	< 0.1%
-1.125853573	1	< 0.1%
-1.173570927	1	< 0.1%
-1.204069609	1	< 0.1%
-1.214176797	1	< 0.1%
-1.218480288	1	< 0.1%
-1.226753925	1	< 0.1%
-1.235716026	1	< 0.1%

audio_mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	312.6 KiB

0	27154
1	12846

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	27154	67.9%
1	12846	32.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	27154	67.9%
1	12846	32.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

speechiness
Real number (ℝ_≥0)

Distinct	39999
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.09410654997

Minimum	0.01506465912
Maximum	0.5607483509
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.01506465912
5-th percentile	0.02929199988
Q1	0.03850013208
median	0.05588077326
Q3	0.1188421391
95-th percentile	0.2765419244
Maximum	0.5607483509
Range	0.5456836918
Interquartile range (IQR)	0.08034200698

Descriptive statistics

Standard deviation	0.08359080853
Coefficient of variation (CV)	0.8882570719
Kurtosis	2.47562356
Mean	0.09410654997
Median Absolute Deviation (MAD)	0.02167172596
Skewness	1.72012054
Sum	3764.261999
Variance	0.006987423271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0333236877	2	< 0.1%
0.1008647319	1	< 0.1%
0.07035114219	1	< 0.1%
0.03681558906	1	< 0.1%
0.3407435176	1	< 0.1%
0.1747890063	1	< 0.1%
0.02650533038	1	< 0.1%
0.1737324419	1	< 0.1%
0.03549234342	1	< 0.1%
0.2614746642	1	< 0.1%
Other values (39989)	39989	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01506465912	1	< 0.1%
0.01515337083	1	< 0.1%
0.01564763501	1	< 0.1%
0.01833354331	1	< 0.1%
0.01853498414	1	< 0.1%
0.01879262041	1	< 0.1%
0.01888181812	1	< 0.1%
0.01888251654	1	< 0.1%
0.019010372	1	< 0.1%
0.01903601699	1	< 0.1%

Value	Count	Frequency (%)
0.5607483509	1	< 0.1%
0.5510141697	1	< 0.1%
0.5477989681	1	< 0.1%
0.5332567197	1	< 0.1%
0.5306210907	1	< 0.1%
0.5274952514	1	< 0.1%
0.5190122249	1	< 0.1%
0.5158757556	1	< 0.1%
0.5149116625	1	< 0.1%
0.5083094875	1	< 0.1%

tempo
Real number (ℝ_≥0)

Distinct	39993
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.5628149

Minimum	62.05577908
Maximum	219.1635782
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	62.05577908
5-th percentile	81.3193984
Q1	96.99530887
median	113.7959594
Q3	128.5173834
95-th percentile	170.9800477
Maximum	219.1635782
Range	157.1077991
Interquartile range (IQR)	31.52207449

Descriptive statistics

Standard deviation	26.16791062
Coefficient of variation (CV)	0.2244962139
Kurtosis	0.1752832209
Mean	116.5628149
Median Absolute Deviation (MAD)	16.00719581
Skewness	0.7641500817
Sum	4662512.595
Variance	684.7595463
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.09594918	2	< 0.1%
90.56198771	2	< 0.1%
95.06923582	2	< 0.1%
88.18238954	2	< 0.1%
103.1900773	2	< 0.1%
127.0865076	2	< 0.1%
111.827571	2	< 0.1%
139.234579	1	< 0.1%
91.92083795	1	< 0.1%
106.6759308	1	< 0.1%
Other values (39983)	39983	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
62.05577908	1	< 0.1%
62.88900161	1	< 0.1%
63.24833569	1	< 0.1%
63.45744669	1	< 0.1%
63.4788765	1	< 0.1%
63.47941256	1	< 0.1%
63.53043311	1	< 0.1%
63.75748185	1	< 0.1%
63.97720182	1	< 0.1%
63.99473878	1	< 0.1%

Value	Count	Frequency (%)
219.1635782	1	< 0.1%
218.6374389	1	< 0.1%
215.8613677	1	< 0.1%
212.5435496	1	< 0.1%
212.4254819	1	< 0.1%
211.7864762	1	< 0.1%
211.5793805	1	< 0.1%
211.1612702	1	< 0.1%
211.0914066	1	< 0.1%
210.480838	1	< 0.1%

time_signature
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	312.6 KiB

3	23358
4	15919
2	530
5	193

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	3
3rd row	3
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
3	23358	58.4%
4	15919	39.8%
2	530	1.3%
5	193	0.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
3	23358	58.4%
4	15919	39.8%
2	530	1.3%
5	193	0.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

audio_valence
Real number (ℝ_≥0)

Distinct	39998
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5806448561

Minimum	0.01339785461
Maximum	1.022557576
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.01339785461
5-th percentile	0.1591460592
Q1	0.3986694172
median	0.5988269955
Q3	0.7596351387
95-th percentile	0.9474466885
Maximum	1.022557576
Range	1.009159721
Interquartile range (IQR)	0.3609657215

Descriptive statistics

Standard deviation	0.2373507637
Coefficient of variation (CV)	0.4087709745
Kurtosis	-0.858197458
Mean	0.5806448561
Median Absolute Deviation (MAD)	0.1804709655
Skewness	-0.1810057441
Sum	23225.79424
Variance	0.05633538502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7457151873	2	< 0.1%
0.6859068849	2	< 0.1%
0.3568781277	1	< 0.1%
0.8643191672	1	< 0.1%
0.2079348175	1	< 0.1%
0.4293615567	1	< 0.1%
0.1475367375	1	< 0.1%
0.5910507462	1	< 0.1%
0.8189060331	1	< 0.1%
0.4127207868	1	< 0.1%
Other values (39988)	39988	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01339785461	1	< 0.1%
0.01735138702	1	< 0.1%
0.02005064357	1	< 0.1%
0.0239495843	1	< 0.1%
0.02765734359	1	< 0.1%
0.02956553866	1	< 0.1%
0.03038483533	1	< 0.1%
0.03141770541	1	< 0.1%
0.0315559735	1	< 0.1%
0.03290055633	1	< 0.1%

Value	Count	Frequency (%)
1.022557576	1	< 0.1%
1.022282685	1	< 0.1%
1.018570938	1	< 0.1%
1.018301592	1	< 0.1%
1.017692764	1	< 0.1%
1.015200333	1	< 0.1%
1.013484216	1	< 0.1%
1.013445519	1	< 0.1%
1.013055487	1	< 0.1%
1.012928548	1	< 0.1%

song_popularity
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	312.6 KiB

0	25424
1	14576

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	25424	63.6%
1	14576	36.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	25424	63.6%
1	14576	36.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	song_duration_ms	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	audio_mode	speechiness	tempo	time_signature	audio_valence	song_popularity
0	0	212990.0	0.642286	0.856520	0.707073	0.002001	10.0	NaN	-5.619088	0	0.082570	158.386236	4	0.734642	0
1	1	NaN	0.054866	0.733289	0.835545	0.000996	8.0	0.436428	-5.236965	1	0.127358	102.752988	3	0.711531	1
2	2	193213.0	NaN	0.188387	0.783524	-0.002694	5.0	0.170499	-4.951759	0	0.052282	178.685791	3	0.425536	0
3	3	249893.0	0.488660	0.585234	0.552685	0.000608	0.0	0.094805	-7.893694	0	0.035618	128.715630	3	0.453597	0
4	4	165969.0	0.493017	NaN	0.740982	0.002033	10.0	0.094891	-2.684095	0	0.050746	121.928157	4	0.741311	0
5	5	188891.0	0.035655	0.825919	0.804528	-0.000005	4.0	0.120758	-6.122926	0	0.039012	115.679128	4	0.709408	0
6	6	161061.0	0.081743	0.673588	0.880181	0.000327	0.0	0.535411	-2.909607	1	0.030902	98.046205	4	0.982729	0
7	7	196202.0	0.259747	0.813214	0.554385	0.000390	8.0	0.276580	-7.794237	0	0.207067	158.626764	3	0.662987	1
8	8	169660.0	NaN	0.653263	0.917034	0.001748	0.0	NaN	-4.422089	0	0.031608	122.382398	3	0.297683	1
9	9	167245.0	0.019617	0.595235	0.820039	0.761884	5.0	0.181098	-5.154293	0	0.054493	110.524824	4	0.535453	0

Last rows

	id	song_duration_ms	acousticness	danceability	energy	instrumentalness	key	liveness	loudness	audio_mode	speechiness	tempo	time_signature	audio_valence	song_popularity
39990	39990	161037.0	NaN	0.180815	0.353495	0.006077	2.0	0.123413	-16.852685	0	0.034193	79.630026	3	0.437497	1
39991	39991	171968.0	0.139985	NaN	0.697060	0.000127	0.0	0.216089	-7.560009	1	0.169939	86.469992	3	0.722420	0
39992	39992	402730.0	0.006045	0.650712	NaN	0.002694	10.0	0.215647	-2.619994	0	0.059303	116.791531	4	0.525806	0
39993	39993	147151.0	0.106588	0.616430	0.923022	0.003327	6.0	0.066085	-4.017034	0	0.185710	118.632683	4	0.393328	1
39994	39994	158043.0	NaN	0.256182	0.699162	0.002757	10.0	0.385996	-9.917717	0	0.042718	103.431785	4	0.208892	1
39995	39995	237799.0	NaN	0.748942	0.511234	0.002913	0.0	0.173803	-8.853673	0	0.078060	168.262924	3	0.178159	0
39996	39996	191119.0	0.067488	0.672830	0.889685	0.001225	5.0	0.122924	-7.798993	0	0.188607	110.684544	3	0.790626	0
39997	39997	160879.0	0.877431	0.409065	0.292671	NaN	10.0	0.110664	-15.378585	0	0.031294	99.556074	3	0.177947	1
39998	39998	193918.0	NaN	0.365738	NaN	0.000339	1.0	0.356308	-4.661977	1	0.054096	139.857384	3	0.772978	0
39999	39999	196475.0	0.007116	0.354585	0.994883	0.002191	1.0	0.200900	-4.875249	0	0.080549	101.974949	3	0.588549	0

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows